Sr. SQL Server / SSIS SSRS SSAS Developer
- Overall 6 yearsof IT experience in Database Administration, System Analysis, Design and Development & Support of MS SQL Server 2012/2008R *** ,QA, and Development & Replication Environments.
- Expertise in SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS)and SQL Server Reporting Services (SSRS).
- Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursorsand Indexesusing T-SQL.
- Experience in creating packages to transfer data between Access, Excel, CSV, Oracle, flat file, Text Data to SQL SERVER using SSIS.
- Experience in developing, monitoring, extractingand transformingdata using SSIS, Import Export Wizard, and Bulk Insert.
- Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation,for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
- Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver *** ),designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Directorand DataStage Debugger.
- Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuningand System Testing.
- Excellent in using highly scalable parallel processing Infrastructure using DataStage Parallel Extender.
- Hands on experience in Designing and implementing Cubes, Dimensions and Measures according to business requirement.
- Hands on experience in Creating Star Schema datamodels and Snow FlakeSchema data models.
- Strong skills in writing MDXqueries to access cubes data in SSAS, and creating feeds from OLTPto OLAPsystems.
- Extensive experience in designing and developing data warehouse and its component tools for data storage.
- Expertise in SQL Server reporting services (SSRS *** in generating complex reports in cascaded reports, parameterized reports and Ad Hoc reports.
- Created different types of reports such as Conditional, Drill-down, Summary and Sub reports, and formatted them and Performed unit testingat various levels.
- Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model using Report Builder.
- Rendered reports in CSV, PDF, XML and delivered reports by file share and E-mail according to schedule.
- Experienced with front-end development using ASP.NET, C#with Visual Studio, v...