We provide IT Staff Augmentation Services!

Database Analyst/etl Developer Resume

4.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Highly motivated SQL Server Developer of Five years and six months IT experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and Crystal Reports.
  • Experienced in client requirement Analysis, development (normalization and SQL Server Enterprise manager), Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS and Crystal Reports.
  • Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts.
  • Developed complex stored procedures, triggers, views and functions with complex logic used in the application.
  • Experience in writing complex SQL queries involving multiple tables inner and outer joins
  • Worked Extensively on ETL process using SSIS package.
  • Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
  • Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Experience in developing and deploying reports using Crystal Reports.
  • Developed complex client/user define reports like Tabular, Sub Reports by assigning the Report Parameters, Drill through and Drill down mode.
  • Developed complex store procedures and views to generate various Drill-Down reports, parameterized reports.
  • Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
  • Can effectively work in a team or as an individual contributor and consistently exceeded expectations with aggressive deadlines.
  • Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS:

Database and Languages: MS SQL Server2005/2008, SQL Server 2000, T-SQL, PL/SQL

Operating Systems: Windows 95/98/NT/2000/XP/2007

Reporting Tools: Crystal Reports XI

ETL Tools: DTS, SSIS

SDLC Methodology: Waterfall

Source Control Tool: VSS, TFS

AVAILABILTY: Immediately

PROFESSIONAL EXPERIENCE:

Confidential

Database Analyst/ETL Developer

  • Involved in design, developing and implementing the logical and physical model for Data mart.
  • Created Database design document
  • Was involved in preparing the Functional Specification Documents with details of the requirements gathered from users and the logic to be implemented.
  • Created databases objects including tables, indexes, views and stored procedure per the design requirements.
  • Created and Tuned T-SQL stored procedures to implement business logic.
  • Used SQL Server Agent to schedule Packages into Jobs as well as T-SQL queries
  • Implemented the Master/Child Package Model so that only the Master Package should be scheduled which will in turn fire the other packages using SSIS 2005
  • Developed ETL System using MSSQL 2005. This system is built using numerous ETL scripts, stored procedures and SSIS packages.
  • Developed and deployed SSIS packages.
  • Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations using SSIS.
  • Optimized existing ETL scripts for reducing the execution time.

Worked on complex SSIS packages for transferring data from heterogeneous database into pre-staging database then profiling the data before populating the data warehouse.

Confidential

Technical Lead, SQL Server Developer, Onsite Coordinator

  • Was responsible for writing complex stored procedures, triggers, views and queries
  • Created indexes, constraints and rules on database objects
  • Analyzed, developed, and implemented database designs, data models and relational database definitions across multiple computing environments.
  • Performing analysis of various enhancements.
  • Performed Impact Analysis, Coding, Unit Testing and System Testing, Handled Operational Requests.
  • Defined and designed the data sourcing and data flows, data quality analysis
  • Identified the data source and defined them to build the data source views
  • Used various transformations while mapping the data from source to destination using SSIS.
  • Used SQL Server Agent to automate the SSIS package execution
  • Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables
  • Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using Crystal Reports
  • Tested and managed the SSIS packages
  • Used SQL Server Agent to schedule Packages into Jobs as well as T-SQL queries
  • Developed ETL System using MSSQL 2005. This system is built using numerous stored procedures and DTS packages.
  • Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations using SSIS.
  • Worked on complex SSIS packages for transferring data from heterogeneous database into pre-staging database then profiling the data before populating the data warehouse.
  • Developed dynamic Business Object Reports, which was greatly welcomed by the client as it is not only the cost saving step but also increased the speed of web reports significantly.
  • Create various complex reports using Crystal Reports
  • Identified and added the report parameters and created the reports based on the requirements using Crystal Reports
  • Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports
  • Used prompts, alerts, drill down analysis as per the end user requirements
  • Create nested, conditional subgroups and formatting features in reports
  • Create Sub reports called from the main report to implement the business logic
  • Interacted with business leaders and application development staff to ensure corporate data is developed, maintained and used appropriately throughout the corporation
  • Oversee all web development and lead the team of 5 to successful execution of project plans.
  • Coordination of project goals and timeline between the higher management and the team.
Confidential

Programmer Analyst, Developer, Technical Lead

  • Responsible for full cycle development of client requirements and includes analysis design, scalable implementation and database object development.
  • Analyzed, developed, and implemented database designs, data models and relational database definitions across multiple computing environments.
  • Project Management
  • Facing the Process Audits
  • Preparation of estimation coordination of the team in monitoring, allocating and aiding complex solutions.
  • Discussions with the Onsite Team to gather the requirements
  • Maintaining the share point for placing the project documents at release level.
  • Code review and Analysis document review
  • Imparting domain and technical knowledge to the new entrants and fellow team members.
  • Ensuring top quality deliverables from Cognizant to client and collection of project metrics
  • Migrating the existing DTS packages in the server to SSIS packages
  • Working on the change requests related to reporting database
  • Management of database - creation of tables, views and stored procedures
  • Data Migration across environments
  • Uploading of data provided by the clients into the specific tables etc.

We'd love your feedback!