| HOTLIST - SUNITHA || ELT DEV || BI DEV || SQL DEV || USC || at Remote, Remote, USA |
| Email: [email protected] |
| From: Eli, RCube Creative Consulting [email protected] Reply to: [email protected] Hello There, NAME : SUNITHA S Locatiuon : MCKINNEY Relocation : 30 Miles Work Authorization : USC PROFESSIONAL SUMMARY: 11 years of Software experience including in Designing, Developing, and Implementing of Business Objects Applications in IT industry and experience of working with different sectors such as Telecom, Health Insurance, Finance, and Airlines. 7+ years of experience in Extensive experience in MS SQL Server 2012 and 2016 Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) 2 years of Power BI experience. 4+ years of experience in Business Objects 4.0/XIR3.1/XIR3/XIR2 (Designer, Webi/Deski, Publishing Wizard, Info view, Broadcast Agent/Scheduler. Involved in the full System Development Life Cycle (Analysis, Development, Deployment, Testing and Documentation). Extensive knowledge on Relational Database Management Systems (RDBMS), OLTP, OLTP and MOLAP. Extensive knowledge on Data Warehousing Star Schema and Snowflake schema. Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) into database tables. Extensive knowledge on building CUBS(MOLAP) using SSAS (SQL server Analysis service). Expertise in creating SSIS packages for extracting data from heterogeneous sources (Excel, CSV, Flat file, excel, PostgreSQL, Oracle) and used Multiple transformations like Data Conversion, Conditional Split, Slowly Changing Dimension (SCD), Bulk Insert, Merge Join, Union ALL, Sort, Multicast, Fuzzy Lookup, Fuzzy Grouping, Lookup, Aggregate, Row count. Expertise in using For Loop Container, Foreach Loop Container, Sequence Container. Experience in using Bulk Insert Task, Send Mail task, FTP task, Execute SQL task. Experience in creating various reports like graphical reporting and adhoc reporting using SQL Server Reporting Services (SSRS). Developed Drill Through (Hyperlink), Drill Down, Parameterized, Tabular, Cross Tab reports (Matrix), Charts reports, cascading Parameterized reports, sub-reports, Subtotals based on GROUPS, Optional Parameterized, variables created for formulas. And percentages. Developed single reports with different databases (Diff data sources) and diff data sets using lookup functions. Experience in creating reports with stored procedures. Expertise in Designing, Developing and managing complex universes using SAP BO. Experience in creating reports using Hyperlinks, Cross Tab, Drill down, Sections, Breaks, Averters, Input controls, Charts and complex reports with multiple data providers. Experience in creating reports using Sub Query, Add Query and Combine Query methods. Experience in creating Query filers with Optional Prompts and required prompts. Experience in reports level filters like Drill Filters, report tab filters, Quick filters using. SAP BO WEBI reports. Involved in Unit Testing and System Testing. Team player with excellent Interpersonal Skills and self-starter, capable of working independently. Ability to adapt to new technologies very quickly. Proficient in understanding the business domain and proactive in taking responsibility in delivering effective solutions in a timely manner. Eager to learn new technologies and improve constantly. Able to work on own initiative or as part of a team, backed by excellent organizational and communication skills along with the capability to solve problems as they arise. Technical Skills BI Tools: SQL SERVER 2012/2013/2016 SSIS/SSRS, SQL SERVER 2012/2016 SSIS/SSR SAP Business Objects 4.0, Business ObjectsXir3.1, Infoview, CMC, and Webi/Deski. Databases: Oracle 10g/9i/ 8i, MS SQL Server 2008/2012/2016s, PostgreSQL Languages: JAVA, COBOL, C, C++, XML, Visual Basic, HTML 4.0, XML. Data Warehousing: Star Schema, Snow Flake Schema, OLTP, OLAP, MOLAP. OS: UNIX, Windows. Other Tools: ALM, JIRA EDUCATION Masters in Computer Applications, Osmania University, India. VISA STATUS US Citizen SKILLS YEARS OF EXP SQL Server (2012/2016 SSIS/SSRS) 7+ years MS SQL Server (2008/2012/2016) 7+ years Business Intelligence (BI) Tools 7+ years SAP Business Objects (4.0/XIR3.1/XIR3/XIR2) 4+ years Power BI 2 years PostgreSQL 4+ years (mentioned with projects) ETL (Extract, Transform, Load) 7+ years (via SSIS) Data Warehousing (Star Schema, Snowflake Schema) Extensive experience SSAS (SQL Server Analysis Services) Extensive knowledge SCD (Slowly Changing Dimension) Expertise (no specific years, included in SSIS tasks) Fuzzy Lookup, Conditional Split, Merge Join, Union ALL, Sort, Aggregate, Row Count Expertise (no specific years, included in SSIS tasks) Stored Procedures Expertise (no specific years, mentioned across projects) JIRA Used in Agile environment (experience across projects) GitKraken Used for version control (mentioned in recent projects) ALM (Application Lifecycle Management) Experience in defect tracking (across projects) TFS (Team Foundation Server) Used in version control (mentioned in projects) For Loop Container, Sequence Container Expertise (no specific years, included in SSIS tasks) Unix, Windows Extensive knowledge (no specific years, mentioned as operating systems used) HTML, XML, Visual Basic, COBOL, C, C++ Extensive experience (no specific years) Java Experience (no specific years mentioned) Reporting (Tabular, Cross Tab, Matrix, Charts) Expertise (years not specified, mentioned across multiple projects) Drill Through, Drill Down, Cascading Parameters Experience (years not specified, covered under SSRS reports) Keywords: cprogramm cplusplus business intelligence information technology microsoft HOTLIST - SUNITHA || ELT DEV || BI DEV || SQL DEV || USC || [email protected] hotlist |
| [email protected] View all |
| Fri Oct 25 20:14:00 UTC 2024 |