Greetings of the day
Kindly find the details of my consultant available for your direct client requirement, on c2c. Kindly share the complete Job description at sadath@mutexsystems.com
Consultant"s info:-
Name: Sirisha
Total exp: 6+ years
Current location: Atlanta GA
Relocation: Open
Visa: H1b
Availability: 1 weeks' notice
Professional Summary
� 6+ years of IT experience with a strong background in Analysis, Design and Development in the
field of Database and implementation of Business Intelligence applications.
� Designed and developed Analytics solutions using SQL, Power BI, PL/SQL, MS SQL, SQL Server, and Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS).
� Performed proper SDLC phases and installed changes into production using the change control system.
� Excellent communication skills at all levels and ability to assess user needs & requirements by interacting with appropriate personnel in various levels and parts of the organization.
� Explore data in a variety of ways and across multiple visualizations using Power BI.
� Created, Maintained & scheduled various reports in Power BI according to the requirements.
� Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
� Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
� Worked on designing dashboard / reports to give them consistent and professional looks using Power BI.
� Created Customized and interactive dashboards using multiple data sources.
� Excellent hands-on experience in groups, hierarchies, and measures, KPIs.
� Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.
� Experience in creating ETL mappings in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping, data cleansing and data quality.
� Published reports to Azure-based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
� Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.
� Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
� Excellent knowledge in Performance tuning methodologies at a database level, ETL, and Report Level.
� Excellent knowledge of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools.
� Expertise in Data Transformation and Data Migration.
� Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
� Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
� Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.
� Work with team for any clarification and queries required in the development phase.
� Experience with software development methodologies and process models like Waterfall and Agile-Scrum.
� Involved in Formal Code Reviews, Peer Reviews, Walkthroughs and Inspections as needed to the project.
� Strong ability to work together in a team environment, as well as work independently and be productive in environments where priorities change.
Technical Proficiencies
DB Platforms: MS SQL Server 2005/2008/2012, Oracle 11g, Oracle 12C, MS Access
DWH/BI Tools: Power BI, SQL Server Business Development - SSIS, SSRS, SSAS, Power BI, Informatica Power Center (Repository Manager, Designer, Work Flow Manager)
Programming Skills: C, C++, PL/SQL, Microsoft SQL Server 2012, 2014, 2018
Visualization Tools: Power BI
Operating Systems: Windows, UNIX, AS/400
Tools/Technologies: SQL, PL/SQL, AWS, Salesforce, Mule soft, Soap UI, XML, HTML,
ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Crystal Reports, Power Pivot, Jira.
Mutex powered by  |