SUMMARY

• 5 years of IT experience in Requirement Analysis, Design, Development, Testing and Implementation of applications and systems using diversified technologies.
• 2 years of experience in leading technical projects.
• 5 years of experience in SRS development, interacting with Clients.
• In depth knowledge of Database administration of MS SQL 2000/2005/2008 , Postgres SQL, MS Access 2000, Oracle.
• Good understanding of Product and Project management concepts.
• Hands on experience in Business Intelligence area.
• Hands on experience in creating tables, views, indexes and relations using SQL Enterprise Manager.
• Experience in design and development of Stored Procedures, UDFs, Triggers, Views, SQLXML using SQL server 2005,MS - SQL Server, Postgres SQL and T-SQL for transactional business applications.
• Hand on experience with ETL tool Informatica, SSIS and DTS .
• Hands on experience working with Tera bytes of data.
• Proficient in Performance Tuning, Query Optimization and running Database.
• Expertise in creating reports using SQL Server Reporting Services (SSRS) and Crystal Reports
• Experience in creating reports using Microstrategy 9.0,Cognos.
• Good knowledge and experience in Data warehousing concepts.
• Experience in developing n-tier web/windows applications using Microsoft .NET technologies.
• Expertise in design, development, maintenance and deployment of service oriented n-tier applications
• Hands on experience in testing various software applications and using different automated testing tools.
• Good knowledge in all phases of testing.
• Complete working experience of various phases of Software Development Life Cycle (SDLC).
• Good knowledge of the work flow analysis and use case diagrams.
• Exceptional ability to quickly master new technology and apply it to full range of capabilities.
• Sharp analytical skills, communication, organizational, testing, problem solving and presentation skills.
• Motivated team player with ability to work independently.

TECHNICAL SKILLS

Operating systems: Microsoft Windows -9X, XP, NT, 2000, Vista, LINUX, UNIX, VAX/VMS

Programming: Asp.Net,C#.Net,VB.Net,C,C++,Java,FORTRAN,HTML,XML,PHP

Databases: SQL Server 2000/2005/2008 , Oracle 8/9i, MySql 4.0, Query Analyzer, PL/SQL, T-SQL, Microsoft Access 2000/2003.

ETL tools: Informatica

Reporting Tools: SSRS,Microstrategy 9.0, Cognos,Pentaho,Crystal Reports (8.0/8.5/9.0).

Tools: Visual SourceSafe 6.0/2005, Microsoft Project, Visio

PROFESSIONAL EXPERIENCE

Confidential, Denver Co

Software Developer

Responsibilities:

• Worked on understanding the daily operations of the team and on call procedures and came up to speed in less than a month’s team .
• Learnt Cognos and started developing complicated report requests to our Educational Partners.
• Good knowledge of Learning Studio Platform and K12.
• Improved the LA teams existing process by creating a product suite for MyLabs Education partners. This product suite was widely appreciated and is used across all MyLabs Educational Partners.
• Learnt an internal tool called ‘Dextor’ based on Bulk Load and Copy concepts .
• Learnt open source reporting tool Pentaho and completed an official training in the same.
• Optimized several queries in Dextor to reduce the run times.
• Led a team of 6 including 3 people in India for converting all the Data manager tasks in Cognos to Dextor.We finished the task of moving 589 reports in 2 months and 5 days with only 2 minor issues which were resolved on the same day .
• Led a team of 3 people for setting up the new Cognos folder set up in Cognos 10.Was able to successfully supervise and provide technical inputs and complete the project in team .
• Held meetings with India team and supervised their work.
• Fixed a number of existing loopholes in Cognos current folder structure.
• Leading 2 developers on SIOA project. Working with them to understand their pain points and requirements and providing technical expertise. Worked on delivering three reports in Pentaho successfully.
• Creating Software Requirement specifications and other necessary deocumentation for report creation.
• Designed and created documentation for large projects like Cognos 10 upgrade, Cognos to Dextor conversion and folder structure setups.
• Interacting with clients on a regular basis to gather the requirements.
• Interacting with Client representatives regulalrly to gather business requirements and present technical solutions.
• Holding meetings to co-ordinate project updates and technical presentations.
• Working on learning Cassandra.
• Working with Athena team to provide help in the Big data side of things.

Confidential, Phoenix AZ

Database Architect/Systems Analyst/ETL developer

Responsibilities:

• Well versed with the data warehousing concepts and processes.
• Involved in the Data warehouse architectural and structural discussions.
• Created a business requirements document highlighting all the sources, database names, table names, columns, data connections that needed to be loaded into Data warehouse.
• Conducted meetings, discussions to gather the requirements from various teams to load their sources into data warehouse.
• Self trained in ETL tool “informatica” by reading online material and watching tutorials.
• Created tables for all the sources in Postgres sql in Greenplum.
• Created connection successfully in informatica and loaded the data into Data warehouse for the initial three sources.
• Shadowed ETL expert and mastered ETL mappings, workflows in informatica in two weeks.
• Worked on building a new process for Web proxy reporting. Conducted meetings with proxy team to gather the requirements, deisgned the process flow and created complicated SQL transformation workflow to load the data into web proxies table in Data warehouse.
• Provided sql queries and the connections needed by the Microstrategy expert to run his reports.
• Attended a five day Microstrategy training session provided by the company.
• Worked on creating heirarchies, relationships and metrics in Microstrategy.
• Created prompted reports for end users in Microstrategy.
• Created the Design and presented the design to the team and other teams for the Global Ip Exclusion process.
• Created a web form using C#.Net as frontend and table as the back end for Global Ip Exclusion process.
• Created a website using C#.Net as frontend and table as the back end for Compliance Reporting.
• Created a tool that parses through the data and gets the enterprise wide compliance information using VB.net.
• Worked on migrating the Data from old servers to new servers and mirroring the servers.
• Worked on generating weekly SLA 37 Reports, and Coverage Metrics Reports for two of our primary vendors
• Migrated servers from sql and Installed SQL Server R2 on different servers.
• Creating numerous mappings and workflows to load more than 50 sources into Data warehouse.
• Debugging, testing, productionalising the mappings and monitoring them for bugs/errors and troubleshooting the errors.
• Working on loading millions of rows into tables using ETL processes.
• Working with Tera bytes of Data.
• Working on creating Databases and tables as and when required.
• Creating adhoc SSRS reports as and when required.
• Fixing reports, troubleshooting jobs, data issues, and queries and creating indexes for performance tuning.
• Working on writing adhocs or SQL Queries as and when required to gather information or generate reports in Excel or other formats.
• Using Microsoft Office tools for importing and exporting the data.

Confidential, Phoenix,AZ

SQL Developer

Responsibilities:

• Created views, triggers, adhocs and stored procedures to handle large volumes of data.
• Worked on creating scripts to generate shadow and production tables.
• Created primary keys and indexes for the tables to enhance the performance.
• Installed MS SQL Server, performed Database Design and created user Database
• Performed Database Integrity checks, updated Database statistics and performed Re-indexing.
• Developed various reports using SSRS and teaching same to developers.
• Designed DTS packages to accommodate new changes in the file structures and layouts.
• Worked on migrating the DTS packages to SSIS packages.
• Helped with Quality Assurance specifically with testing the adhocs and stored procedures.
• Created software using C#.NET, Win Forms, and SQL Server.
• Worked on generating test cases and documenting the test results.
• Designed test plans and performing user acceptance testing.
• Worked on testing the SSIS packages using Integration Services.
• Generated Crystal reports for end users and interacting with them on regular basis.

Confidential, Springfield, IL

Software Developer

Responsibilities:

• Installed MS SQL Server, Business Intelligence Studio configuration
• Created and managed schema objects such as tables, views, clusters, indexes
• Created complex reports such as drill down, drill through reports using SQL Server Reporting Services.
• Wrote complex stored procedures, triggers and functions
• Programmed displays for Department Early warning software.
• Programmed displays for the emergency Action Level monitoring program.
• Helped in testing the existing displays and documenting the test results.
• Worked on creating plans and budgeting.
• Assisted in the maintenance of the agency’s reactor Data link Database.
• Worked on Data analysis and creating Functional requirements.
• Worked on planning and risk analysis phases for migrating from FORTRAN to .Net Framework 3.0.

Confidential, Springfield, IL

Multicultural Assistant

Responsibilities:

• Designed fliers for various events using Dreamweaver and Photoshop.
• Organized various events and managed the teams that helped coordinate the events.

Confidential, Ruston, Louisiana

Teaching Assistant

Responsibilities:

• Assisted the professor in grading and updating the grades in the online system.
• Conducted C++, Java workshops for undergraduate students.
• Trained the undergraduate students in coding and testing the applications in Java and C++.
• Trained the students in designing test cases and executing the test cases using some automated testing tools.